SELECT * FROM
(select NAME NMT1, COUNT(*) QTD1 
from SYSIBM.SYSCOLUMNS 
GROUP BY NAME) T1
LEFT JOIN 
(select NAME NMT2, COLTYPE, LENGTH, SCALE, COUNT(*) QTD2 
from SYSIBM.SYSCOLUMNS
GROUP BY NAME, COLTYPE, LENGTH, SCALE) T2
ON T1.NMT1 = T2.NMT2 
WHERE QTD1 <> QTD2


SELECT C.NAME, C.TBCREATOR, C.TBNAME, COLTYPE, LENGTH, SCALE FROM SYSIBM.SYSCOLUMNS C
JOIN SYSIBM.SYSTABLES T
ON C.TBNAME=T.NAME AND C.TBCREATOR=T.CREATOR
WHERE T.TYPE='T' AND
C.NAME IN
(SELECT DISTINCT NMT1 FROM
(select NAME NMT1, COUNT(*) QTD1 
from SYSIBM.SYSCOLUMNS 
GROUP BY NAME) T1
LEFT JOIN 
(select NAME NMT2, COLTYPE, LENGTH, SCALE, COUNT(*) QTD2 
from SYSIBM.SYSCOLUMNS
GROUP BY NAME, COLTYPE, LENGTH, SCALE) T2
ON T1.NMT1 = T2.NMT2 
WHERE QTD1 <> QTD2)
ORDER BY NAME, TBNAME, TBCREATOR